﻿using EmoneyWeiXinCommon;
using EmoneyWeiXinEntity;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace EmoneyWeiXinDAL
{
    [Serializable]
    public class SecurityDAL
    {
        public List<Security> GetAllStocks()
        {
            string sql = "select * from dbo.[Security] with(nolock) where SecuCategory in ('001001','001002') and ListState<>'013002'";
            return SQLHelper.GetDataByColumnsLst<Security>(Config.Default, sql, null);
        }
    }
}
 